AL Synchronize Databases

AL Synchronize Databases synchronizes the data of Microsoft Dynamics 365 Business Central to external databases (PostgreSQL, Microsoft SQL) through configurable nodes and interfaces, with a buffer, logs and a Web API - a data integration engine for BI, datalakes, e-commerce and third-party systems.

Key capabilities

• Nodes and interfaces - node, node group and node interface (with fields and a log) define which data/tables to synchronize, to which external database and with which field mapping.
• Pluggable engine - an AL interface with implementations for PostgreSQL and Microsoft SQL, JSON handling, a synchronize buffer and an SQL log.
• Table setup - which tables, with synchronization and action types and an SQL status.
• Web API - node, node interface, buffer and NAS APIs for orchestration and monitoring.

Why it matters

• BC data where you need it - replicate or expose Business Central data on external databases.
• Configurable, not coded - nodes, interfaces and field mapping instead of custom export jobs.
• Monitored - a buffer, logs and a Web API for governance.
• BI and integration ready - feed datalakes, BI and third-party systems.

Built for

IT and integration teams that need to feed external systems with Business Central data - for BI, datalakes, e-commerce or third-party integrations - in a configurable, monitored way.

What makes AL Synchronize Databases different

• A configurable sync model - nodes, interfaces and field mapping.
• Pluggable database engine - PostgreSQL and Microsoft SQL implementations.
• Monitored - buffer, SQL log and a Web API for orchestration.

How it works

Set up the nodes (external databases), the interfaces (tables and field mapping) and the synchronization type. As data changes in Business Central, the buffer is fed and the engine writes to the external databases (PostgreSQL/Microsoft SQL) per the interface, with logging; you monitor through the logs and the Web API.

Requirements

• Microsoft Dynamics 365 Business Central online (SaaS), version 25.0 or higher.
• Languages - English (en-US) and Italian (it-IT).
• Targets - PostgreSQL and Microsoft SQL external databases; confirm the connection channel and security for your scenario.
• Dependencies (installed automatically) - AL License and Trial Management and AL Role Center, from AppLibra.